SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 68136: The SUBSTR() function is not passed to Hadoop and the SAS® log contains the message "Streaming read CTAS error: Error while compiling statement..."

DetailsHotfixAboutRate It

When you attempt to use the SUBSTR() function and the third argument is not an integer, the query is not passed to Hadoop. In this scenario, an error similar to the following is printed in the SAS® log:

HADOOP: Streaming read CTAS error: Error while compiling statement: FAILED:

ParseException line 1:352 mismatched input 'instr' expecting Number near '('

in primitive type specification

HADOOP: Reverting to non-CTAS HiveQL

Click the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS/ACCESS Interface to HadoopMicrosoft® Windows® for x649.479.479.4 TS1M79.4 TS1M7
64-bit Enabled AIX9.479.479.4 TS1M79.4 TS1M7
64-bit Enabled Solaris9.479.479.4 TS1M79.4 TS1M7
HP-UX IPF9.479.479.4 TS1M79.4 TS1M7
Linux for x649.479.479.4 TS1M79.4 TS1M7
Solaris for x649.479.479.4 TS1M79.4 TS1M7
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.